AdClassSched

Logical Entity Name | AdClassSched
Default Table Name | AdClassSched
Physical Only | NO
Owner | dbo
Definition |
Note |

AdClassSched Columns

ColumnName | Domain | Datatype | NULL | Definition
Code |  | char(12) | NO |
Section |  | varchar(8) | NO |
Descrip |  | varchar(75) | NO |
AdCourseID |  | int | NO |
SyCampusID |  | int | NO |
MaxStudents |  | int | NO |
RegStudents |  | int | NO |
AdTeacherID |  | int | NO |
AttendanceType |  | char(1) | YES |
LDA |  | datetime | YES |
NextDateAtt |  | datetime | YES |
StartDate |  | datetime | YES |
EndDate |  | datetime | YES |
ModFlag |  | char(1) | NO |
Active |  | bit | NO |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
AdClassSchedID |  | int | NO |
SchedComment |  | varchar(4000) | YES |
UnschedDays |  | bit | YES |
DropAbsentPct |  | numeric(5, 2) | YES |
DropConsAbsent |  | numeric(6, 0) | YES |
DropCumAbsent |  | numeric(6, 0) | YES |
WarnAbsentPct |  | numeric(5, 2) | YES |
WarnConsAbsent |  | numeric(6, 0) | YES |
WarnCumAbsent |  | numeric(6, 0) | YES |
MakeUpMaxType |  | char(1) | YES |
MakeUpMaxNum |  | numeric(7, 2) | YES |
WaitlistExpiredOrCleared |  | bit | NO |
StartTime |  | datetime | YES |
DaysFlag |  | int | NO |
SyllabusDocument |  | varchar(255) | YES |
FinalRegStudents |  | int | NO |
FinalRegDropStudents |  | int | NO |
AllowWaitListing |  | bit | NO |
WaitListMaxNumOfSeats |  | int | NO |
AllowReservations |  | bit | NO |
adDeliveryMethodID |  | int | YES |
HideFaculty |  | bit | NO |
HideLocation |  | bit | NO |
BlindGrading |  | bit | NO |
SendToLMS |  | bit | NO |
AuditAdvisementRequired |  | bit | YES |
AdShiftID |  | int | YES |
PassFailSetting |  | tinyint | NO |
DefaultMeetingLengthStudentSpecific |  | int | NO |
AllowStudentSpecificMeeting |  | bit | NO |
AddedAdClassSchedId |  | int | NO |
ThresholdType |  | bit | YES |
ThresholdNumOfSeats |  | smallint | YES |
SyLmsVendorID |  | int | YES |
LmsExtractStatus |  | char(1) | YES |
ClassSchedLength |  | int | YES |
MaxSections |  | int | NO |
AutoAdded |  | bit | NO |
EnrollStatusCredits |  | money | NO |
EnrollStatusHours |  | money | NO |
AddDropDate |  | datetime | YES |
AddDropManual |  | bit | NO |
LDWDate |  | datetime | YES |
LDWManual |  | bit | NO |
EnforceAttendanceLDW |  | bit | NO |
AutoDropWarningForLDW |  | bit | NO |
Credits |  | money | YES |
Hours |  | money | YES |
AllowOverride |  | bit | NO |
MinCredits |  | money | YES |
MaxCredits |  | money | YES |
SecondarySectionCode |  | nvarchar(16) | YES |
IsCanceled |  | bit | NO |
UnRegisterEndDate |  | datetime | YES |
DropEndDate |  | datetime | YES |
InstructorHoursAssigned |  | numeric(5, 2) | YES |

AdClassSched Primary and Unique Keys

Key Name | Key Type | Keys
AdClassSched_AdCourseID_StartDate_EndDate_AdClassSchedId_U_N_IDX | Index | AdCourseID, StartDate, EndDate, AdClassSchedID
AdClassSched_AdClassSchedID_U_C_IDX | PrimaryKey | AdClassSchedID

AdClassSched Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
adDeliveryMethod | Non-Identifying | Zero or One to Zero or More | FK_adClassSched.adDeliveryMethodID_adDeliveryMethod.adDeliveryMethodID |  |  | adDeliveryMethodID | NO | YES
adShift | Non-Identifying | Zero or One to Zero or More | FK_AdClassSched_AdShiftID_AdShift_AdShiftID |  |  | AdShiftID | NO | YES
SyLmsVendor | Non-Identifying | Zero or One to Zero or More | Fk_AdClassSched_SyLmsVendorID_SyLmsVendor_SyLmsVendorID |  |  | SyLmsVendorID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
AdClassFeeSched | Non-Identifying | One To Zero or More | FK_AdClassFeeSched_AdClassSchedID_AdClassSched_AdClassSchedIDID |  |  |  | NO | YES
AdClassSchedBookList | Non-Identifying | One To Zero or More | FK_AdClassSchedBookListAdClassSchedID_AdClassSchedAdClassSchedID |  |  |  | NO | YES
AdClassSchedCrossRegGroup | Non-Identifying | One To Zero or More | FK_AdClassSchedCrossRegGroup_AdClassSchedID_AdClassSched_AdClassSchedID |  |  |  | NO | YES
AdClassSchedInstructor | Non-Identifying | One To Zero or More | FK_AdClassSchedInstructor.AdClassSchedID_AdClassSched.AdClassSchedID |  |  |  | NO | YES
AdClassSchedInstructorAttributes | Non-Identifying | One To Zero or More | FK_AdClassSchedInstructorAttributesAdClassSchedID_AdClassSchedAdClassSchedID |  |  |  | NO | YES
AdCrossListSection | Non-Identifying | One To Zero or More | FK_AdCrossListSection_AdClassSchedID_AdClassSched_AdClassSchedID_U_N_IDX |  |  |  | NO | YES
AdEnrollRegistration | Identifying | One To Zero or More | FK_AdEnrollRegistration_AdClassSched_AdClassSched_AdClassSchedID |  |  |  | NO | YES
AdLessonPlanCourseMap | Non-Identifying | One To Zero or More | FK_AdLessonPlanCourseMap_AdClassSchedID_AdClassSched_AdClassSchedID |  |  |  | NO | YES
CmDocumentPermit | Non-Identifying | One To Zero or More | FK_CmDocumentPermitAdClassSchedID_AdClassSchedAdClassSchedID |  |  |  | NO | YES
SaAutoBillBatchDetail | Non-Identifying | One To Zero or More | FK_SaAutoBillBatchDetailAdClassSchedId_AdClassSchedAdClassSchedId |  |  |  | NO | YES
SaEnrollRevenue | Non-Identifying | One To Zero or More | Fk_SaEnrollRevenue_AdClassSchedID_AdClassSched_AdClassSchedID |  |  |  | NO | YES
SaPendingCharge | Non-Identifying | One To Zero or More | Fk_SaPendingCharge_AdClassSchedID_AdClassSched_AdClassSchedID |  |  |  | NO | YES
SaPendingChargeCourseAmount | Non-Identifying | One To Zero or More | FK_SaPendingChargeCourseAmount_AdClassSchedId_AdClassSched_AdClassSchedId |  |  |  | NO | YES
SaTrans | Non-Identifying | One To Zero or More | Fk_SaTrans_AdClassSchedID_AdClassSched_AdClassSchedID |  |  |  | NO | YES
SaTransCourse | Non-Identifying | One To Zero or More | FK_SaTransCourse_AdClassSchedID_AdClassSched_AdClassSchedID |  |  |  | NO | YES
SaTransCourseAmount | Non-Identifying | One To Zero or More | FK_SaTransCourseAmount_AdClassSchedId_SaTrans_AdClassSchedId |  |  |  | NO | YES

AdClassSched Check Constraints

Check Constraint Name | CheckConstraint
Chk_AdClassSched_MakeUpMaxNum | ([MakeUpMaxType] = 'P' and ([MakeUpMaxNum] >= 0 and [MakeUpMaxNum] <= 100) or [MakeUpMaxType] = 'H' or [MakeUpMaxType] = null and [MakeUpMaxNum] = null)

AdClassSched Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

AdClassSched Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.ClassSection | NO |  |  |
Physical (Microsoft SQL Server) dbo.AdClassSched | NO |  |  |

AdClassSched Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | ClassScheduling
Logical | CourseRegistration
Logical | Documents
Logical | LedgerCard_Billing
Logical | Tasks
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records

AdClassSched Data Movement Rules

Name | Type | Rule Text/Value